<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE topic
  PUBLIC "-//OASIS//DTD DITA Composite//EN" "ditabase.dtd">
<topic xml:lang="en" id="topic_sln_wfx_tz">
  <title>pg_available_extension_versions</title>
  <body>
    <p>The <codeph>pg_available_extension_versions</codeph> view lists the specific extension
      versions that are available for installation. The <xref href="pg_extension.xml"
          ><i>pg_extension</i></xref> system catalog table shows the extensions currently
      installed.</p>
    <p>The view is read only.</p>
    <table id="table_tln_wfx_tz">
      <title>pg_catalog.pg_available_extension_versions</title>
      <tgroup cols="3">
        <colspec colnum="1" colname="col1" colwidth="131pt"/>
        <colspec colnum="2" colname="col2" colwidth="86pt"/>
        <colspec colnum="3" colname="col4" colwidth="147pt"/>
        <thead>
          <row>
            <entry colname="col1">column</entry>
            <entry colname="col2">type</entry>
            <entry colname="col4">description</entry>
          </row>
        </thead>
        <tbody>
          <row>
            <entry colname="col1"><codeph>name</codeph></entry>
            <entry colname="col2">name</entry>
            <entry colname="col4">Extension name.</entry>
          </row>
          <row>
            <entry colname="col1"><codeph>version</codeph></entry>
            <entry colname="col2">text</entry>
            <entry colname="col4">Version name.</entry>
          </row>
          <row>
            <entry colname="col1"><codeph>installed</codeph></entry>
            <entry colname="col2">boolean</entry>
            <entry colname="col4"><codeph>True</codeph> if this version of this extension is
              currently installed, <codeph>False</codeph> otherwise.</entry>
          </row>
          <row>
            <entry colname="col1"><codeph>superuser</codeph></entry>
            <entry colname="col2">boolean</entry>
            <entry colname="col4"><codeph>True</codeph> if only superusers are allowed to install
              the extension, <codeph>False</codeph> otherwise.</entry>
          </row>
          <row>
            <entry colname="col1"><codeph>relocatable</codeph></entry>
            <entry colname="col2">boolean</entry>
            <entry colname="col4"><codeph>True</codeph> if extension can be relocated to another
              schema, <codeph>False</codeph> otherwise.</entry>
          </row>
          <row>
            <entry colname="col1"><codeph>schema</codeph></entry>
            <entry colname="col2">name</entry>
            <entry colname="col4">Name of the schema that the extension must be installed into, or
                <codeph>NULL</codeph> if partially or fully relocatable.</entry>
          </row>
          <row>
            <entry colname="col1"><codeph>requires</codeph></entry>
            <entry colname="col2">name[]</entry>
            <entry colname="col4">Names of prerequisite extensions, or <codeph>NULL</codeph> if
              none</entry>
          </row>
          <row>
            <entry colname="col1"><codeph>comment</codeph></entry>
            <entry colname="col2">text</entry>
            <entry colname="col4">Comment string from the extension control file.</entry>
          </row>
        </tbody>
      </tgroup>
    </table>
  </body>
</topic>
